﻿

/*单位缓存*/
CREATE PROCEDURE [dbo].[proc_Company_Range_Getlist_All_News]
	
AS
Select Id,
		CompanyName,
		CompanyNumber,
		dwbh,
		(SELECT COUNT(0) FROM Company) AS coun
--	 From Company Order by CompanyNumber
From Company Order by (Select M.CompanyNumber From ManagementArea M Where M.Id=Company.Mid) ASC,CompanyNumber

	RETURN



